package com.qyj.spring_boot_02.mapper.clickhouse;
import com.qyj.spring_boot_02.bean.*;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;

public interface DataMapper {
    List<KeyWord> getKeyWord();
    List<SkuClassName> getSkuClassName();
    @Select("select id,name,count from dws_sp_pl_count_num")
    List<SpPlCountNum> getSpPlCountNumList();
    List<TimePingLunCount> getTimePingLunCountList();
    List<PriceRangeBean> getPriceRange();
    List<PeizhiKeyWordBean> getPeizhiKeyWord(@Param("start") Integer start,@Param("pageNum") Integer pageNum);
    List<PingLunkeyWordCountBean> getPingLunKeyWordCount(@Param("start") Integer page,@Param("pageNum") Integer pageNum);
    List<PingPaifenLeiBean> getPinPaifenLeiPingLun();
    List<PingPaifenLeiBean> getPinPaifenLeiChangPing();
    List<SkuHaoPingAvgBean> getSkuHaoPingAvgBean();
    String getSkuNameWithSkuClass(@Param("skuClass") String skuClass);
    List<SkuXiaoCount> getSkuXiaoCount();
    List<Integer> getYearIsInTableList();
    List<LocationCountBean> getLocationCountMapper(@Param("year") String year);
    List<LocationCountBean> getLocationPingLunCountMapper(@Param("year") String year);
    List<LocationDateXiaoLiang> getLocationDateXiaoLiang();
    List<LocationCountBean> getLocationCountQdNumXiaoLiang(@Param("year") Integer year,@Param("jidu") String jidu);
    List<PinPaiCountXiaoBean> getPinPaiCountXiaoBean(@Param("year") Integer year,@Param("jidu") String jidu);
    List<ShiyinWithTimeBean> getShiyinWithTimeBeanList(@Param("year") String year,@Param("jidu") String jidu,
                                                       @Param("page") Integer page,@Param("pageNum") Integer pageNum);
    List<TimeForCountBean> getKeshihuaData();
    List<PriceRangeQjBean> getPriceRangeQjBeanList(@Param("skuClass") String skuClass);
    List<String> getAllskuClass();
    List<TimeCountAndXiaoCount> getTimeCountWithSkuClass(@Param("skuClass") String skuClass);
    List<SelectLocationWhereSkuClassBean> getSelectLocationWhereSkuClassBeanList(@Param("skuClass") String skuClass);
    List<GetKeyWordBySkuClassBean> getGetKeyWordBySkuClass(@Param("skuClass") String skuClass,
                                                           @Param("page") Integer page,
                                                           @Param("pageNum") Integer pageNum);
}
